 CREATE TABLE `carts` (
`ID` VARCHAR( 10 ) NOT NULL ,
`DATE` DATE NOT NULL ,
`IP` VARCHAR( 20 ) NOT NULL ,
PRIMARY KEY ( `ID` )
) ENGINE = MYISAM;

 CREATE TABLE `items` (
`ID` VARCHAR( 10 ) NOT NULL ,
`NAME` VARCHAR( 50 ) NOT NULL ,
`PRICE` FLOAT NOT NULL ,
`DESCRIPTION` VARCHAR( 100 ) NOT NULL ,
PRIMARY KEY ( `ID` )
) ENGINE = MYISAM;

 CREATE TABLE `rel` (
`ID_CART` VARCHAR( 10 ) NOT NULL ,
`ID_ITEM` VARCHAR( 10 ) NOT NULL ,
`AMOUNT` INT NOT NULL ,
PRIMARY KEY ( `ID_CART` , `ID_ITEM` )
) ENGINE = MYISAM;